drop database if exists duckweed_system;
create database duckweed_system default character set utf8mb4 collate utf8mb4_general_ci;

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for article
-- ----------------------------
DROP TABLE IF EXISTS `article`;
CREATE TABLE `article` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `article_type_code` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT '文章类型编号',
  `image` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL COMMENT '图片',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1626437833474424833 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC COMMENT='文章列表';

-- ----------------------------
-- Records of article
-- ----------------------------
BEGIN;
INSERT INTO `article` VALUES (1563118525466427392, '1563385493535264459', '');
INSERT INTO `article` VALUES (1563416136027140096, '1563415493535264768,1563426774375919616', NULL);
INSERT INTO `article` VALUES (1563420118934024192, '1563415493535264768,1563426261370597376', NULL);
INSERT INTO `article` VALUES (1563421328562909184, '1563415493535264768,1563425956063014912', NULL);
INSERT INTO `article` VALUES (1563494499538427904, '1563415493535264768,1563416379904946176', NULL);
INSERT INTO `article` VALUES (1563494697362776064, '1563415493535264768,1563422664922689536', NULL);
INSERT INTO `article` VALUES (1563812636446081024, '1563415493535264768,1563811778257928192', NULL);
INSERT INTO `article` VALUES (1563840251852673024, '1563415493535264768,1563840055018180608', NULL);
INSERT INTO `article` VALUES (1597872000799563776, '1563415493535264768,1597871435382726658', NULL);
INSERT INTO `article` VALUES (1598240890801049600, '1563385493535264457', NULL);
INSERT INTO `article` VALUES (1598526470025801728, '1598526208314355714', NULL);
INSERT INTO `article` VALUES (1598556336670588928, '1598526208314355714', NULL);
INSERT INTO `article` VALUES (1598556518585942016, '1598526208314355714', NULL);
INSERT INTO `article` VALUES (1598556665843761152, '1598526208314355714', NULL);
INSERT INTO `article` VALUES (1601846983458680832, '1563415493535264768,1601834541477691394', NULL);
INSERT INTO `article` VALUES (1601847255568347136, '1563415493535264768,1601834604807487490', NULL);
INSERT INTO `article` VALUES (1601848008278142976, '1563415493535264768,1601834713549012994', NULL);
INSERT INTO `article` VALUES (1601848110174564352, '1563415493535264768,1601834783736496129', NULL);
INSERT INTO `article` VALUES (1601848770009886720, '1563415493535264768,1601834950300696578', NULL);
INSERT INTO `article` VALUES (1601850558524026880, '1563415493535264768,1601837598380773378', NULL);
INSERT INTO `article` VALUES (1601875149694816256, '1563415493535264768,1601874505433198593', NULL);
INSERT INTO `article` VALUES (1602558851930537984, '1563385493535264459', '');
INSERT INTO `article` VALUES (1603221843663863808, '1603221635114172418', NULL);
INSERT INTO `article` VALUES (1622466399856455680, '1563415493535264768,1622465814797692929', NULL);
INSERT INTO `article` VALUES (1626437833474424832, '1603221635114172418', NULL);
COMMIT;

-- ----------------------------
-- Table structure for article_details
-- ----------------------------
DROP TABLE IF EXISTS `article_details`;
CREATE TABLE `article_details` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `language_id` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT '语言code',
  `article_id` bigint NOT NULL COMMENT '文章列表ID',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '文章标题',
  `url` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL COMMENT '跳转地址',
  `keyword` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '关键字',
  `text_content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '文本内容',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1626437833503784961 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC COMMENT='文章详情';

-- ----------------------------
-- Records of article_details
-- ----------------------------
BEGIN;
INSERT INTO `article_details` VALUES (1563118525508370432, 'zh_CN', 1563118525466427392, '微澜量化平台', NULL, NULL, '<p>微澜量化平台</p>', '2022-08-26 18:57:52', '2023-04-24 12:02:02');
INSERT INTO `article_details` VALUES (1563416136064888832, 'zh_CN', 1563416136027140096, '【Duckweed】修改资金密码', NULL, NULL, '【Duckweed】修改资金密码', '2022-09-08 14:57:37', '2022-12-02 14:18:13');
INSERT INTO `article_details` VALUES (1563420118959190016, 'zh_CN', 1563420118934024192, '【Duckweed】修改邮箱', NULL, NULL, '【Duckweed】修改邮箱', '2022-09-08 11:50:18', '2022-12-02 14:18:23');
INSERT INTO `article_details` VALUES (1563421328596463616, 'zh_CN', 1563421328562909184, '【Duckweed】账号注册', NULL, NULL, '【Duckweed】账号注册', '2022-09-08 10:50:32', '2022-12-02 14:19:22');
INSERT INTO `article_details` VALUES (1563494499643285504, 'zh_CN', 1563494499538427904, '确认提现', NULL, NULL, '确认提现', '2022-09-08 16:28:56', '2022-12-01 19:05:26');
INSERT INTO `article_details` VALUES (1563494697408913408, 'zh_CN', 1563494697362776064, '【Duckweed】提现成功提醒 - ${time}', NULL, NULL, '【Duckweed】提现成功提醒 - ${time}', '2022-09-08 16:50:06', '2022-11-16 14:38:50');
INSERT INTO `article_details` VALUES (1563812636525772800, 'zh_CN', 1563812636446081024, '提现验证码', NULL, NULL, '提现验证码', '2022-09-08 16:45:16', '2022-08-28 16:56:14');
INSERT INTO `article_details` VALUES (1563840251903004672, 'zh_CN', 1563840251852673024, '【Duckweed】充值成功提醒 - ${time}', NULL, NULL, '【Duckweed】充值成功提醒 - ${time}', '2022-09-08 15:44:45', '2022-11-16 11:35:25');
INSERT INTO `article_details` VALUES (1597872000845701120, 'zh_CN', 1597872000799563776, '【Duckweed】登录', NULL, NULL, '【Duckweed】登录', '2022-11-30 16:35:47', '2022-11-30 16:40:51');
INSERT INTO `article_details` VALUES (1598240890855575552, 'zh_CN', 1598240890801049600, '一键托管-策略开启后勿动欧易账户', NULL, NULL, '一键托管-策略开启后勿动欧易账户', '2022-12-01 17:01:37', '2023-02-15 23:45:11');
INSERT INTO `article_details` VALUES (1598526470134853632, 'zh_CN', 1598526470025801728, '1.如何绑定OKX的API?', '', NULL, '1.如何绑定OKX的API?', '2022-12-02 11:56:24', '2023-01-17 18:55:47');
INSERT INTO `article_details` VALUES (1598556336762863616, 'zh_CN', 1598556336670588928, '2.区块链简史：激荡十二年', 'https://www.ccvalue.cn/article/220997.html', NULL, '2.区块链简史：激荡十二年', '2022-12-02 13:55:05', '2023-02-05 17:26:56');
INSERT INTO `article_details` VALUES (1598556518623690752, 'zh_CN', 1598556518585942016, '3.Duckweed AI新会员答疑？', NULL, NULL, '3.Duckweed AI新会员答疑？', '2022-12-02 13:55:48', '2023-02-05 14:40:02');
INSERT INTO `article_details` VALUES (1598556665864732672, 'zh_CN', 1598556665843761152, '4.币圈早知道', NULL, NULL, '4.币圈早知道', '2022-12-02 13:56:24', '2022-12-14 16:52:28');
INSERT INTO `article_details` VALUES (1601846983613870080, 'zh_CN', 1601846983458680832, '【Duckweed】策略开启通知 - ${time}', NULL, NULL, '【Duckweed】策略开启通知 - ${time}', '2022-12-11 15:50:56', '2022-12-11 16:05:48');
INSERT INTO `article_details` VALUES (1601847255627067392, 'zh_CN', 1601847255568347136, '【Duckweed】策略关闭通知 - ${time}', NULL, NULL, '【Duckweed】策略关闭通知 - ${time}', '2022-12-11 15:52:01', '2022-12-11 17:16:45');
INSERT INTO `article_details` VALUES (1601848008332668928, 'zh_CN', 1601848008278142976, '【Duckweed】策略暂停通知 - ${time}', NULL, NULL, '【Duckweed】策略暂停通知 - ${time}', '2022-12-11 15:55:01', '2022-12-11 16:24:21');
INSERT INTO `article_details` VALUES (1601848110279421952, 'zh_CN', 1601848110174564352, '【Duckweed】策略恢复通知 - ${time}', NULL, NULL, '【Duckweed】策略恢复通知 - ${time}', '2022-12-11 15:55:25', '2022-12-11 16:05:26');
INSERT INTO `article_details` VALUES (1601848770072801280, 'zh_CN', 1601848770009886720, '【Duckweed】策略异常通知 - ${time}', NULL, NULL, '【Duckweed】策略异常通知 - ${time}', '2022-12-11 15:58:02', '2022-12-11 21:07:26');
INSERT INTO `article_details` VALUES (1601850558578552832, 'zh_CN', 1601850558524026880, '【Duckweed】燃油币账户余额不足通知 - ${time}', NULL, NULL, '【Duckweed】燃油币账户余额不足通知 - ${time}', '2022-12-11 16:05:09', '2022-12-11 16:31:55');
INSERT INTO `article_details` VALUES (1601875149766119424, 'zh_CN', 1601875149694816256, '【Duckweed】策略异常解决通知', NULL, NULL, '【Duckweed】策略异常解决通知', '2022-12-11 17:42:52', '2022-12-11 17:43:05');
INSERT INTO `article_details` VALUES (1602558852001841152, 'zh_CN', 1602558851930537984, '轮播图', NULL, NULL, '<p>轮播图</p>', '2022-12-13 14:59:39', '2023-04-24 12:01:58');
INSERT INTO `article_details` VALUES (1602559645031481344, 'zh_CN', 1602559645023092736, '轮播图', NULL, NULL, '轮播图', '2022-12-13 15:02:48', NULL);
INSERT INTO `article_details` VALUES (1602563933526966272, 'zh_CN', 1602563933518577664, '轮播图', NULL, NULL, '轮播图', '2022-12-13 15:19:51', NULL);
INSERT INTO `article_details` VALUES (1602563975205765120, 'zh_CN', 1602563975197376512, '轮播图', NULL, NULL, '轮播图', '2022-12-13 15:20:01', NULL);
INSERT INTO `article_details` VALUES (1603221843710001152, 'zh_CN', 1603221843663863808, '1.什么是去中心化', NULL, NULL, '1.什么是去中心化', '2022-12-15 10:54:09', '2023-02-09 19:33:59');
INSERT INTO `article_details` VALUES (1622466400221360128, 'zh_CN', 1622466399856455680, '【Duckweed】修改授权地址', NULL, NULL, '【Duckweed】修改授权地址', '2023-02-06 13:25:08', '2023-02-06 13:39:10');
INSERT INTO `article_details` VALUES (1626437833503784960, 'zh_CN', 1626437833474424832, '2.交易常用辅助平台汇总-仅供参考，不做投资建议', '', NULL, '2.交易常用辅助平台汇总-仅供参考，不做投资建议', '2023-02-17 12:26:12', '2023-02-17 12:33:05');
COMMIT;

-- ----------------------------
-- Table structure for article_type
-- ----------------------------
DROP TABLE IF EXISTS `article_type`;
CREATE TABLE `article_type` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '类型id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '类型名称',
  `parent_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '上级类型编号',
  `relation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '上下级类型编号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1622465814797692930 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='文章类型';

-- ----------------------------
-- Records of article_type
-- ----------------------------
BEGIN;
INSERT INTO `article_type` VALUES (1563385493535264457, '公告', NULL, '1563385493535264457');
INSERT INTO `article_type` VALUES (1563385493535264458, '帮助', NULL, '1563385493535264458');
INSERT INTO `article_type` VALUES (1563385493535264459, 'Banner', NULL, '1563385493535264459');
INSERT INTO `article_type` VALUES (1563385493535264460, '联系我们', NULL, '1563385493535264460');
INSERT INTO `article_type` VALUES (1563415493535264768, '邮件模板', NULL, '1563415493535264768');
INSERT INTO `article_type` VALUES (1563415882619875328, '合约强制平仓通知', '1563415493535264768', '1563415493535264768,1563415882619875328');
INSERT INTO `article_type` VALUES (1563415994377105408, '合约追加保证金', '1563415493535264768', '1563415493535264768,1563415994377105408');
INSERT INTO `article_type` VALUES (1563416379904946176, '确认提现', '1563415493535264768', '1563415493535264768,1563416379904946176');
INSERT INTO `article_type` VALUES (1563422664922689536, '提现成功', '1563415493535264768', '1563415493535264768,1563422664922689536');
INSERT INTO `article_type` VALUES (1563425956063014912, '用户注册', '1563415493535264768', '1563415493535264768,1563425956063014912');
INSERT INTO `article_type` VALUES (1563426261370597376, '用户修改邮箱', '1563415493535264768', '1563415493535264768,1563426261370597376');
INSERT INTO `article_type` VALUES (1563426774375919616, '用户修改支付密码', '1563415493535264768', '1563415493535264768,1563426774375919616');
INSERT INTO `article_type` VALUES (1563811778257928192, '提现验证码', '1563415493535264768', '1563415493535264768,1563811778257928192');
INSERT INTO `article_type` VALUES (1563840055018180608, '充值成功', '1563415493535264768', '1563415493535264768,1563840055018180608');
INSERT INTO `article_type` VALUES (1574649347681890305, '成为经纪人', '1563415493535264768', '1563415493535264768,1574649347681890305');
INSERT INTO `article_type` VALUES (1574649475801100290, '经纪人返佣到账', '1563415493535264768', '1563415493535264768,1574649475801100290');
INSERT INTO `article_type` VALUES (1579457127578869761, '资金账户后台-充值/奖励/平台手工', '1563415493535264768', '1563415493535264768,1579457127578869761');
INSERT INTO `article_type` VALUES (1579457280129900545, '资金账户后台-冻结', '1563415493535264768', '1563415493535264768,1579457280129900545');
INSERT INTO `article_type` VALUES (1580866101288968193, '意见反馈已通过', '1563415493535264768', '1563415493535264768,1580866101288968193');
INSERT INTO `article_type` VALUES (1587322868700221442, '新建API密钥', '1563415493535264768', '1563415493535264768,1587322868700221442');
INSERT INTO `article_type` VALUES (1587323133868314626, 'API开启提现', '1563415493535264768', '1563415493535264768,1587323133868314626');
INSERT INTO `article_type` VALUES (1592427508411879425, 'API查询密钥', '1563415493535264768', '1563415493535264768,1592427508411879425');
INSERT INTO `article_type` VALUES (1597871435382726658, '邮箱登录', '1563415493535264768', '1563415493535264768,1597871435382726658');
INSERT INTO `article_type` VALUES (1598526208314355714, '快问快答', NULL, '1598526208314355714');
INSERT INTO `article_type` VALUES (1601834541477691394, '【Duckweede】开启策略通知', '1563415493535264768', '1563415493535264768,1601834541477691394');
INSERT INTO `article_type` VALUES (1601834604807487490, '【Duckweede】关闭策略通知', '1563415493535264768', '1563415493535264768,1601834604807487490');
INSERT INTO `article_type` VALUES (1601834713549012994, '【Duckweede】策略暂停通知', '1563415493535264768', '1563415493535264768,1601834713549012994');
INSERT INTO `article_type` VALUES (1601834783736496129, '【Duckweede】策略恢复通知', '1563415493535264768', '1563415493535264768,1601834783736496129');
INSERT INTO `article_type` VALUES (1601834950300696578, '【Duckweede】策略异常通知', '1563415493535264768', '1563415493535264768,1601834950300696578');
INSERT INTO `article_type` VALUES (1601837598380773378, '【Duckweede】燃油币账户余额不足通知', '1563415493535264768', '1563415493535264768,1601837598380773378');
INSERT INTO `article_type` VALUES (1601874505433198593, '【Duckweede】策略异常解决', '1563415493535264768', '1563415493535264768,1601874505433198593');
INSERT INTO `article_type` VALUES (1603221635114172418, '区块链小知识', NULL, '1603221635114172418');
INSERT INTO `article_type` VALUES (1622465814797692929, '修改地址', '1563415493535264768', '1563415493535264768,1622465814797692929');
COMMIT;

-- ----------------------------
-- Table structure for feedback
-- ----------------------------
DROP TABLE IF EXISTS `feedback`;
CREATE TABLE `feedback` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `uid` bigint DEFAULT NULL COMMENT '用户id',
  `state` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '反馈状态（已提交，已采纳，未采纳，详情字典项feedback_state）',
  `feedback_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '反馈类型(功能Bug，安全漏洞，产品建议，详情字典项feedback_type)',
  `problem_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '问题描述',
  `write_back` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '系统回复',
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '图片/视频',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `reward_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '奖励类型',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='反馈意见';

-- ----------------------------
-- Records of feedback
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_language
-- ----------------------------
DROP TABLE IF EXISTS `sys_language`;
CREATE TABLE `sys_language` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '语言名称',
  `code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '语言编号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1564515181231542273 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC COMMENT='系统语言';

-- ----------------------------
-- Records of sys_language
-- ----------------------------
BEGIN;
INSERT INTO `sys_language` VALUES (1, '香港中文简体', 'zh_CN');
INSERT INTO `sys_language` VALUES (2, '香港中文繁體', 'zh_TW');
INSERT INTO `sys_language` VALUES (3, 'English', 'en_US');
COMMIT;

-- ----------------------------
-- Table structure for system_log
-- ----------------------------
DROP TABLE IF EXISTS `system_log`;
CREATE TABLE `system_log` (
  `id` bigint NOT NULL COMMENT '主键',
  `log_id` bigint DEFAULT NULL COMMENT '当操作会导致一系列其它日志时，标记为同一个logId',
  `operator_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '操作人类型（0系统、1用户、2管理人员）',
  `type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '类型',
  `old_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '旧数据',
  `new_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '新数据',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `create_by` bigint NOT NULL COMMENT '创建人id',
  `create_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人名称',
  `update_time` datetime NOT NULL COMMENT '修改时间',
  `update_by` bigint NOT NULL COMMENT '修改人id',
  `update_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '修改人名称',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '状态（无意义）',
  `is_deleted` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '是否删除（0否、null是）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='操作日志';

-- ----------------------------
-- Records of system_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for system_platform
-- ----------------------------
DROP TABLE IF EXISTS `system_platform`;
CREATE TABLE `system_platform` (
  `id` bigint NOT NULL COMMENT '主键',
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '平台名称',
  `url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'API真实环境接口路径',
  `test_url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'API测试环境接口路径',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `create_by` bigint NOT NULL COMMENT '创建人id',
  `create_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人名称',
  `update_time` datetime NOT NULL COMMENT '修改时间',
  `update_by` bigint NOT NULL COMMENT '修改人id',
  `update_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '修改人名称',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '状态（0停用、1正常）',
  `is_deleted` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '是否删除（0否、null是）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='平台';

-- ----------------------------
-- Records of system_platform
-- ----------------------------
BEGIN;
INSERT INTO `system_platform` VALUES (1597116882951192576, '欧易', 'https://www.okx.com', 'https://www.okx.com', '2022-11-28 14:35:13', 2, '管理员', '2022-12-03 19:03:22', 2, '管理员', '1', '0');
COMMIT;

-- ----------------------------
-- Table structure for system_product
-- ----------------------------
DROP TABLE IF EXISTS `system_product`;
CREATE TABLE `system_product` (
  `id` bigint NOT NULL COMMENT '主键',
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '种类（0永续合约）',
  `symbol_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '币对名称',
  `platform_id` bigint NOT NULL COMMENT '平台id',
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '产品名称',
  `sheet_value` decimal(32,8) DEFAULT NULL COMMENT '合约张数面值',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `create_by` bigint NOT NULL COMMENT '创建人id',
  `create_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人名称',
  `update_time` datetime NOT NULL COMMENT '修改时间',
  `update_by` bigint NOT NULL COMMENT '修改人id',
  `update_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '修改人名称',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '状态（0停用、1正常）',
  `is_deleted` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '是否删除（0否、null是）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='产品';

-- ----------------------------
-- Records of system_product
-- ----------------------------
BEGIN;
INSERT INTO `system_product` VALUES (1596411626818752512, '0', 'ETHUSDT', 1597116882951192576, 'ETH-USDT-SWAP', 0.10000000, '2022-11-26 15:52:46', 2, '管理员', '2022-12-03 19:21:54', 2, '管理员', '1', '0');
INSERT INTO `system_product` VALUES (1601912484759121920, '0', 'BTCUSDT', 1597116882951192576, 'BTC-USDT-SWAP', 0.01000000, '2022-12-11 20:11:13', 2, '管理员', '2022-12-11 20:11:13', 2, '管理员', '1', '0');
INSERT INTO `system_product` VALUES (1601914315417628672, '0', 'TRXUSDT', 1597116882951192576, 'TRX-USDT-SWAP', 1000.00000000, '2022-12-11 20:18:29', 2, '管理员', '2022-12-11 20:18:29', 2, '管理员', '1', '0');
INSERT INTO `system_product` VALUES (1601914504119365632, '0', 'ETCUSDT', 1597116882951192576, 'ETC-USDT-SWAP', 10.00000000, '2022-12-11 20:19:14', 2, '管理员', '2022-12-11 20:19:14', 2, '管理员', '1', '0');
COMMIT;

-- ----------------------------
-- Table structure for system_symbol
-- ----------------------------
DROP TABLE IF EXISTS `system_symbol`;
CREATE TABLE `system_symbol` (
  `id` bigint NOT NULL COMMENT '主键',
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '币对名称',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `create_by` bigint NOT NULL COMMENT '创建人id',
  `create_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人名称',
  `update_time` datetime NOT NULL COMMENT '修改时间',
  `update_by` bigint NOT NULL COMMENT '修改人id',
  `update_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '修改人名称',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '状态（0停用、1正常）',
  `is_deleted` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '是否删除（0否、null是）',
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'logo图片',
  `chain` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '公链',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='币对';

-- ----------------------------
-- Records of system_symbol
-- ----------------------------
BEGIN;
INSERT INTO `system_symbol` VALUES (1595693232251297792, 'ETHUSDT', '2022-11-24 16:18:08', 2, '管理员', '2023-01-06 16:28:35', 2, '管理员', '1', '0', 'https://roocontract.oss-cn-hangzhou.aliyuncs.com/ETH.png', 'Ethereum');
INSERT INTO `system_symbol` VALUES (1595693232251297793, 'BTCUSDT', '2022-11-24 16:18:08', 2, '管理员', '2023-01-06 16:28:39', 2, '管理员', '1', '0', 'https://roocontract.oss-cn-hangzhou.aliyuncs.com/BTC.png', 'Bitcoin');
INSERT INTO `system_symbol` VALUES (1598558951311622144, 'TRXUSDT', '2022-12-02 14:05:28', 2, '管理员', '2023-01-06 16:28:30', 2, '管理员', '1', '0', 'https://roocontract.oss-cn-hangzhou.aliyuncs.com/TRX.png', 'Tron');
INSERT INTO `system_symbol` VALUES (1598559004071772160, 'FILUSDT', '2022-12-02 14:05:41', 2, '管理员', '2023-01-06 16:27:46', 2, '管理员', '1', '0', 'https://rooexchanges.oss-cn-chengdu.aliyuncs.com/FIL.png', 'Filecoin');
INSERT INTO `system_symbol` VALUES (1598559033595478016, 'ETCUSDT', '2022-12-02 14:05:48', 2, '管理员', '2023-01-06 16:27:43', 2, '管理员', '1', '0', 'https://roocontract.oss-cn-hangzhou.aliyuncs.com/ETC.png', 'Etcereum');
COMMIT;

-- ----------------------------
-- Table structure for undo_log
-- ----------------------------
DROP TABLE IF EXISTS `undo_log`;
CREATE TABLE `undo_log` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `branch_id` bigint NOT NULL,
  `xid` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `context` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `rollback_info` longblob NOT NULL,
  `log_status` int NOT NULL,
  `log_created` datetime NOT NULL,
  `log_modified` datetime NOT NULL,
  `ext` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `ux_undo_log` (`xid`,`branch_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of undo_log
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
